﻿--修改ICP
CREATE PROCEDURE [dbo].[proc_SiteICP_Update]
	(
	   
	    @XingZhi Nvarchar(50),
	    @ZhengJian Nvarchar(50),
	    @Faren Nvarchar(50),
	    @ShengFen Nvarchar(50),
	    @City Nvarchar(50),
	    @Address Nvarchar(100),
	    @FZR_Name Nvarchar(50),
	    @FZR_Sex Nvarchar(50),
	    @FZR_ZhengJian Nvarchar(50),
	    @FZR_Tel Nvarchar(50),
	    @FZR_Fax Nvarchar(50),
	    @FZR_Mobile Nvarchar(50),
	    @FZR_Email Nvarchar(50),
	    @WebName Nvarchar(50),
	    @WebAddress Nvarchar(50),
	    @KongJian_Size Nvarchar(10),
	    @KongJian_Year Nvarchar(10),
	    @ICP_num Nvarchar(20),
	    @Sales Nvarchar(50),
	    @id int
	)
AS
	Update siteicp set
			      XingZhi=@XingZhi,
                                              ZhengJian=@ZhengJian,
			      Faren=@Faren,
			      ShengFen=@ShengFen,
		                    City=@City,
			      Address=@Address,
			      FZR_Name=@FZR_Name,
			     FZR_Sex=@FZR_Sex,
		                   FZR_ZhengJian=@FZR_ZhengJian,
			      FZR_Tel=@FZR_Tel,
			      FZR_Fax=@FZR_Fax,
			      FZR_Mobile=@FZR_Mobile,
			      FZR_Email=@FZR_Email,
			      WebName=@WebName,
			      WebAddress=@WebAddress,
			      KongJian_Size=@KongJian_Size,
                                              KongJian_Year=@KongJian_Year,
                                              ICP_num=@ICP_num,
			      Sales=@Sales,
			      UpTime=getdate()
			where id=@id